parse file

Hello,

how would one parse the transition log the print a csv file in the following format? I am assuming reg expression would be the best solution just not sure of the correct syntax for my problem. Any help would be appreciated. Thank you.

record ID, entered, 2012/03/06 16:51:18, assigned, 2012/05/31 13:12:15, resolved, 2012/05/31 13:23:12, obsolete, 2013/02/13 10:56:52

-Jim
 

Submitted to entered by Ahmed Tawfik (ahmed.tawfik) on 2012/03/06 16:51:18
...
Text
...
Transitioned to assigned by Constance Walker (constance.walker) on 2012/05/31 13:12:15
<comments not supplied>
...
Text
...
Transitioned to resolved by Ricky Parks (ricky.parks) on 2012/05/31 13:23:12
<comments not supplied>
...
Text
...
Transitioned to obsolete by _change_admin on 2013/02/13 10:56:52

Re: parse file
llandale - Thu Feb 14 14:48:17 EST 2013

Let me scribble to start things off

Regexp re_Submitted = regexp2(    //
        "^Submitted to "
        "(entered)"           // match 1 status ignored -
        " by "
        "(.*\(.*\))"          // match 2 Name ignored looks like 'Ahmed Tawfik (ahmed.tawfik)' -
        " on "
        ".*"                  // match 3 Date, looks like '2012/03/06 16:51:18'       -
                        )
Regexp re_Transmitted = regexp2(        
        "^Submitted to "
        "(.*)"                        // match 1 status -
        " by "
        "(.*\(.*\))"          // match 2 Name ignored looks like 'Ahmed Tawfik (ahmed.tawfik)' -
        " on "
        ".*"                  // match 3 Date, looks like '2012/03/06 16:51:18'       -
                        )

-Louie